﻿CREATE TABLE [dbo].[Customers] (
    [CustomerId]  INT          IDENTITY (1, 1) NOT NULL,
    [UserName]    VARCHAR (8)  NOT NULL,
    [Password]    VARCHAR (10)  NOT NULL,
    [RoleId]      INT          NOT NULL,
    [FirstName]   VARCHAR (50) NOT NULL,
    [LastName]    VARCHAR (50) NOT NULL,
    [Gender]      CHAR (1)     NOT NULL,
    [DateOfBirth] DATE         NOT NULL
);

